CREATE TABLE [dbo].[Activity_Attach]
(
[ATTACH_SEQN] [int] NOT NULL CONSTRAINT [DF_Activity_Attach_ATTACH_SEQN] DEFAULT ((0)),
[TEMPLATE] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Activity_Attach_TEMPLATE] DEFAULT (''),
[ATTACH_TEXT] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Activity_Attach_ATTACH_TEXT] DEFAULT (''),
[ACTIVITY_SEQN] [int] NOT NULL CONSTRAINT [DF_Activity_Attach_ACTIVITY_SEQN] DEFAULT ((0)),
[FILE_NAME] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Activity_Attach_FILE_NAME] DEFAULT (''),
[FILE_TIMESTAMP] [datetime] NULL,
[INTENT_TO_EDIT] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Activity_Attach_INTENT_TO_EDIT] DEFAULT (''),
[ATTACH_IMAGE] [image] NULL,
[READ_ONLY] [bit] NOT NULL CONSTRAINT [DF_Activity_Attach_READ_ONLY] DEFAULT ((0)),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
ALTER TABLE [dbo].[Activity_Attach] ADD CONSTRAINT [PK_Activity_Attach] PRIMARY KEY NONCLUSTERED ([ATTACH_SEQN]) ON [PRIMARY]
GO
CREATE CLUSTERED INDEX [iActivity_AttachACTIVITY_SEQN] ON [dbo].[Activity_Attach] ([ACTIVITY_SEQN]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Activity_Attach] TO [IMIS]
GRANT SELECT ON  [dbo].[Activity_Attach] TO [IMIS]
GRANT INSERT ON  [dbo].[Activity_Attach] TO [IMIS]
GRANT DELETE ON  [dbo].[Activity_Attach] TO [IMIS]
GRANT UPDATE ON  [dbo].[Activity_Attach] TO [IMIS]
GO